USE [master]
GO
/****** Object:  Database [WebSMS]    Script Date: 2024/8/12 18:26:36 ******/
CREATE DATABASE [WebSMS]
    CONTAINMENT = NONE
    ON  PRIMARY
    ( NAME = N'WebSMS', FILENAME = N'D:\SQLServerExpress\MSSQL16.SQLEXPRESS\MSSQL\DATA\WebSMS.mdf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )
    LOG ON
    ( NAME = N'WebSMS_log', FILENAME = N'D:\SQLServerExpress\MSSQL16.SQLEXPRESS\MSSQL\DATA\WebSMS_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )
WITH CATALOG_COLLATION = DATABASE_DEFAULT, LEDGER = OFF
GO
ALTER DATABASE [WebSMS] SET COMPATIBILITY_LEVEL = 160
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
    begin
        EXEC [WebSMS].[dbo].[sp_fulltext_database] @action = 'enable'
    end
GO
ALTER DATABASE [WebSMS] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [WebSMS] SET ANSI_NULLS OFF
GO
ALTER DATABASE [WebSMS] SET ANSI_PADDING OFF
GO
ALTER DATABASE [WebSMS] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [WebSMS] SET ARITHABORT OFF
GO
ALTER DATABASE [WebSMS] SET AUTO_CLOSE ON
GO
ALTER DATABASE [WebSMS] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [WebSMS] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [WebSMS] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [WebSMS] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [WebSMS] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [WebSMS] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [WebSMS] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [WebSMS] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [WebSMS] SET  ENABLE_BROKER
GO
ALTER DATABASE [WebSMS] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [WebSMS] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [WebSMS] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [WebSMS] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [WebSMS] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [WebSMS] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [WebSMS] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [WebSMS] SET RECOVERY SIMPLE
GO
ALTER DATABASE [WebSMS] SET  MULTI_USER
GO
ALTER DATABASE [WebSMS] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [WebSMS] SET DB_CHAINING OFF
GO
ALTER DATABASE [WebSMS] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )
GO
ALTER DATABASE [WebSMS] SET TARGET_RECOVERY_TIME = 60 SECONDS
GO
ALTER DATABASE [WebSMS] SET DELAYED_DURABILITY = DISABLED
GO
ALTER DATABASE [WebSMS] SET ACCELERATED_DATABASE_RECOVERY = OFF
GO
ALTER DATABASE [WebSMS] SET QUERY_STORE = ON
GO
ALTER DATABASE [WebSMS] SET QUERY_STORE (OPERATION_MODE = READ_WRITE, CLEANUP_POLICY = (STALE_QUERY_THRESHOLD_DAYS = 30), DATA_FLUSH_INTERVAL_SECONDS = 900, INTERVAL_LENGTH_MINUTES = 60, MAX_STORAGE_SIZE_MB = 1000, QUERY_CAPTURE_MODE = AUTO, SIZE_BASED_CLEANUP_MODE = AUTO, MAX_PLANS_PER_QUERY = 200, WAIT_STATS_CAPTURE_MODE = ON)
GO
USE [WebSMS]
GO
/****** Object:  Table [dbo].[Datas]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Datas](
                              [Id] [uniqueidentifier] NOT NULL,
                              [DataType] [int] NOT NULL,
                              CONSTRAINT [PK_Datas] PRIMARY KEY CLUSTERED
                                  (
                                   [Id] ASC
                                      )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Departments]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Departments](
                                    [Id] [uniqueidentifier] NOT NULL,
                                    [ParentId] [uniqueidentifier] NULL,
                                    [Name] [varchar](100) NOT NULL,
                                    [Description] [varchar](100) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Menus]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Menus](
                              [Id] [uniqueidentifier] NOT NULL,
                              [Name] [varchar](100) NOT NULL,
                              [Path] [varchar](100) NOT NULL,
                              [Icon] [varchar](100) NOT NULL,
                              [ParentMenu] [uniqueidentifier] NULL,
                              [Priority] [int] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[PostDepartmentLinks]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PostDepartmentLinks](
                                            [Id] [uniqueidentifier] NOT NULL,
                                            [PostId] [uniqueidentifier] NOT NULL,
                                            [DepartmentId] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Posts]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Posts](
                              [Id] [uniqueidentifier] NOT NULL,
                              [Name] [varchar](100) NOT NULL,
                              [Description] [varchar](100) NOT NULL,
                              [DepartmentId] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RuleDataLinks]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RuleDataLinks](
                                      [Id] [uniqueidentifier] NOT NULL,
                                      [RuleId] [uniqueidentifier] NOT NULL,
                                      [DataTypeId] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[RuleMenuLinks]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RuleMenuLinks](
                                      [Id] [uniqueidentifier] NOT NULL,
                                      [RuleId] [uniqueidentifier] NOT NULL,
                                      [MenuId] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Rules]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Rules](
                              [Id] [uniqueidentifier] NOT NULL,
                              [Name] [varchar](100) NOT NULL,
                              [Description] [varchar](100) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserDepartmentLinks]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserDepartmentLinks](
                                            [Id] [uniqueidentifier] NOT NULL,
                                            [UserId] [uniqueidentifier] NOT NULL,
                                            [DepartmentId] [uniqueidentifier] NOT NULL,
                                            [CreateTime] [varchar](100) NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserMenuAuthorityLinks]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserMenuAuthorityLinks](
                                               [Id] [uniqueidentifier] NOT NULL,
                                               [UserId] [uniqueidentifier] NOT NULL,
                                               [MenuId] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserPostLinks]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserPostLinks](
                                      [Id] [uniqueidentifier] NOT NULL,
                                      [UserId] [uniqueidentifier] NOT NULL,
                                      [PostId] [uniqueidentifier] NOT NULL,
                                      [CreatedTime] [datetime] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[UserRuleLinks]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserRuleLinks](
                                      [Id] [uniqueidentifier] NOT NULL,
                                      [UserId] [uniqueidentifier] NOT NULL,
                                      [RuleId] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Users]    Script Date: 2024/8/12 18:26:36 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
                              [Id] [uniqueidentifier] NOT NULL,
                              [Username] [varchar](100) NOT NULL,
                              [Email] [varchar](100) NOT NULL,
                              [Phone] [varchar](100) NOT NULL,
                              [IsActive] [bit] NOT NULL,
                              [Password] [varchar](100) NOT NULL,
                              [IsDeleted] [bit] NOT NULL,
                              [CreateDate] [varchar](100) NULL,
                              [BanDate] [varchar](100) NULL,
                              [DeleteDate] [varchar](100) NULL
) ON [PRIMARY]
GO
INSERT [dbo].[Datas] ([Id], [DataType]) VALUES (N'18e52c01-f507-4a5b-a055-28ee3a49e88a', 0)
INSERT [dbo].[Datas] ([Id], [DataType]) VALUES (N'febfdc24-deed-4792-974d-68660440d979', 3)
INSERT [dbo].[Datas] ([Id], [DataType]) VALUES (N'd2bf4f82-2893-4183-b71e-bfd5f9d4170a', 2)
INSERT [dbo].[Datas] ([Id], [DataType]) VALUES (N'793ebfae-0070-4088-a102-e6c96e35b3c0', 1)
GO
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'8032f9dd-d9e6-4dc3-86a7-7d7e896b47be', NULL, N'公司总部', N'公司总部')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'77bc5c19-0d1b-4b54-9713-df49acfe655f', N'8032f9dd-d9e6-4dc3-86a7-7d7e896b47be', N'财务部', N'负责公司的财务管理')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'1a3e858b-04c4-4575-abbd-e5a0013caf7b', N'8032f9dd-d9e6-4dc3-86a7-7d7e896b47be', N'人力资源部', N'负责公司的人员招聘和管理')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'd3f188b3-4af8-4abd-944b-cbde07edcf50', N'8032f9dd-d9e6-4dc3-86a7-7d7e896b47be', N'市场部', N'负责公司的市场营销')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'24307dc8-db6d-4352-bef7-fbf015805919', N'8032f9dd-d9e6-4dc3-86a7-7d7e896b47be', N'研发部', N'负责公司的产品研发')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'a14d928a-31d1-4d82-bbb8-057915607b90', NULL, N'北京分部', N'公司北京分部')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'8b938c64-6e90-45fc-997f-0e79e5fa1760', N'a14d928a-31d1-4d82-bbb8-057915607b90', N'北京财务部', N'负责北京分部的财务管理')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'd8b23e19-729d-4aed-81dc-99c68f51ff33', N'a14d928a-31d1-4d82-bbb8-057915607b90', N'北京人力资源部', N'负责北京分部的人员招聘和管理')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'9cc2a0c1-6ab6-4d27-8f29-af36ba671be1', N'a14d928a-31d1-4d82-bbb8-057915607b90', N'北京市场部', N'负责北京分部的市场营销')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'e53e01e9-e687-4ab1-ae43-ee887b65c5ef', N'a14d928a-31d1-4d82-bbb8-057915607b90', N'北京研发部', N'负责北京分部的产品研发')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'ad925337-d7c5-44b9-a5ce-64a0584b920d', NULL, N'上海分部', N'公司上海分部')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'209cfc03-9156-4b52-9c3c-3e637cfed459', N'ad925337-d7c5-44b9-a5ce-64a0584b920d', N'上海财务部', N'负责上海分部的财务管理')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'd639d418-0c71-4989-b01a-629d83df2f19', N'ad925337-d7c5-44b9-a5ce-64a0584b920d', N'上海人力资源部', N'负责上海分部的人员招聘和管理')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'4a3a2fb8-da81-495d-b1ca-f6146357b515', N'ad925337-d7c5-44b9-a5ce-64a0584b920d', N'上海市场部', N'负责上海分部的市场营销')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'3a4f83e3-8e90-4751-9cf0-f5efc3bc948d', N'ad925337-d7c5-44b9-a5ce-64a0584b920d', N'上海研发部', N'负责上海分部的产品研发')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'c4f1ac44-5443-4e90-852e-d659144b6694', N'3fa85f64-5717-4562-b3fc-2c963f66afa6', N'string', N'string')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'702585fe-222e-4fc5-9ea0-aa5aa6f6336a', NULL, N'杭州分部', N'杭州分部（研发部总部）')
INSERT [dbo].[Departments] ([Id], [ParentId], [Name], [Description]) VALUES (N'61b2510a-4b40-41ed-90ff-e71bb1f5911b', N'702585fe-222e-4fc5-9ea0-aa5aa6f6336a', N'人事部', N'人事部')
GO
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'2ee18837-e1ab-493c-936c-bf93f2f6ab79', N'仪表盘', N'/panel', N'Odometer', NULL, 0)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'bf17dc53-5092-4081-aeaa-10c13aa10540', N'用户管理', N'/users', N'User', NULL, 1)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'f0685ad9-0405-49d2-8c96-aa5469fe2f31', N'角色管理', N'/role', N'Lock', NULL, 1)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'bfe148a2-e4d0-4547-a99f-d760a7621fd2', N'系统设置', N'/settings', N'Setting', NULL, 4)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'31373312-2fb0-4697-92b4-5edba5e097a2', N'用户列表', N'/user-list', N'User', N'bf17dc53-5092-4081-aeaa-10c13aa10540', 1)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'7c296ad4-455d-4559-a9d5-bb3ef7fc0ff3', N'岗位管理', N'/posts', N'Briefcase', NULL, 5)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'57cc05c4-2bc9-4f38-8179-6e1ec7de30ea', N'用户权限', N'/user-authority', N'Unlock', N'bf17dc53-5092-4081-aeaa-10c13aa10540', 3)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'52a84524-f3b9-42b7-b82d-f2edf143da8f', N'用户组管理', N'/user-management/groups', N'UserFilled', N'bf17dc53-5092-4081-aeaa-10c13aa10540', 4)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'a6b5bb35-f423-4d66-af0a-73a1060b6208', N'用户活动日志', N'/user-management/activity', N'Notebook', N'bf17dc53-5092-4081-aeaa-10c13aa10540', 5)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'11b2a69e-948b-430e-88f4-199b1c8de249', N'角色列表', N'/role-list', N'Expand', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31', 1)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'49eba7ef-0746-4648-935f-6ddb5e0788da', N'string', N'string', N'string', N'3fa85f64-5717-4562-b3fc-2c963f66afa6', 0)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'36f2439c-9b04-4c25-8caa-7c5196e36705', N'角色权限', N'/rule-authority', N'Lock', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31', 3)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'91d2ff42-aa79-44d2-80c4-20bd6a341858', N'角色组管理', N'/role-management/groups', N'Connection', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31', 4)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'd6fac68a-25a8-4a59-bf03-8069337bf726', N'角色活动日志', N'/role-management/activity', N'el-icon-document', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31', 5)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'0e824edd-19a0-4e7f-87ed-5fb7b225ed00', N'菜单管理', N'/settings-menu', N'el-icon-s-operation', N'bfe148a2-e4d0-4547-a99f-d760a7621fd2', 1)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'd33486c9-0a26-4c8e-879a-ba2369af48ea', N'系统日志', N'/system-settings/logs', N'el-icon-document', N'bfe148a2-e4d0-4547-a99f-d760a7621fd2', 2)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'e4e7bc74-f27f-4939-91e3-5b066ef4cbbe', N'参数设置', N'/system-settings/parameters', N'el-icon-setting', N'bfe148a2-e4d0-4547-a99f-d760a7621fd2', 3)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'94f8e7d9-b817-4af2-b651-36969e3eeb0b', N'安全设置', N'/system-settings/security', N'el-icon-lock', N'bfe148a2-e4d0-4547-a99f-d760a7621fd2', 4)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'd3655013-4660-4e9d-8d89-0b47a2b42142', N'备份与恢复', N'/system-settings/backup', N'el-icon-refresh', N'bfe148a2-e4d0-4547-a99f-d760a7621fd2', 5)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'f357acbb-4c1b-4353-aade-a5929ff503ac', N'通知管理', N'/notification-management', N'el-icon-bell', NULL, 6)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'3ea44a7c-9efb-4864-8aa8-2dfbd731b2ba', N'通知列表', N'/notification-management/list', N'el-icon-menu', NULL, 1)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'a715e41e-f75b-4ab2-9b9b-d35842b94b52', N'帮助中心', N'/help-center', N'el-icon-question', NULL, 7)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'1d4a3d6c-1b0c-40e7-aad8-ededb7968d89', N'菜单222', N'/menu222', N'Avatar', NULL, 22)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'27fb7119-a411-4f9e-b0ae-2e2b492e29d6', N'部门管理', N'/department', N'HomeFilled', NULL, 3)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'4b8e6d5a-aa92-4760-9471-0cb1a58d22fe', N'部门权限', N'/department-authority', N'Key', N'27fb7119-a411-4f9e-b0ae-2e2b492e29d6', 15)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'eda86e6c-80d2-4b88-908e-50ae3f95788f', N'部门列表', N'/department-list', N'Document', N'27fb7119-a411-4f9e-b0ae-2e2b492e29d6', 15)
INSERT [dbo].[Menus] ([Id], [Name], [Path], [Icon], [ParentMenu], [Priority]) VALUES (N'773b2fb7-692a-4ae3-886b-eb121cdccea6', N'岗位列表', N'/posts-list', N'Tickets', N'7c296ad4-455d-4559-a9d5-bb3ef7fc0ff3', 5)
GO
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'112e62b2-6fec-4e4e-8538-4722e0514ec3', N'财务经理', N'负责财务部整体管理', N'77bc5c19-0d1b-4b54-9713-df49acfe655f')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'54d147fc-b379-449b-b105-2850e05d29eb', N'会计', N'负责日常财务工作', N'77bc5c19-0d1b-4b54-9713-df49acfe655f')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'cb90e2a4-63f3-4bb5-8780-5bbebe67266e', N'出纳', N'负责现金的管理', N'77bc5c19-0d1b-4b54-9713-df49acfe655f')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'e1910afb-3625-43da-9eec-3734936057d9', N'人事经理', N'负责公司人事管理', N'1a3e858b-04c4-4575-abbd-e5a0013caf7b')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'ffdf4e16-ba38-4ca9-8591-60c33b95cee1', N'招聘专员', N'负责人员招聘', N'1a3e858b-04c4-4575-abbd-e5a0013caf7b')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'9e4f81b5-f862-44af-919d-3451b2e6dff4', N'培训专员', N'负责人员培训', N'1a3e858b-04c4-4575-abbd-e5a0013caf7b')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'5e3babb3-2347-49e4-bc7c-3cadb0a08380', N'市场经理', N'负责市场部整体管理', N'd3f188b3-4af8-4abd-944b-cbde07edcf50')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'2adca2ca-232e-4d49-a238-45708778967c', N'市场调研员', N'负责市场调研工作', N'd3f188b3-4af8-4abd-944b-cbde07edcf50')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'77290dfe-711f-4b24-a009-df7f0c7a29cd', N'研发经理', N'负责研发部整体管理', N'8032f9dd-d9e6-4dc3-86a7-7d7e896b47be')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'2be145d6-a07b-461c-b503-cabe0d83f7db', N'产品研发工程师', N'负责产品研发', N'702585fe-222e-4fc5-9ea0-aa5aa6f6336a')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'6688c3bd-6a67-4c9f-81b3-3da5cab202bc', N'产品维护工程师', N'负责产品维护', N'24307dc8-db6d-4352-bef7-fbf015805919')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'2db54806-269b-4c5a-adc0-f4fd4e49ef6c', N'北京财务经理', N'负责北京分部财务管理', N'8b938c64-6e90-45fc-997f-0e79e5fa1760')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'09fb2848-c117-42a5-a735-78ffdc71be7d', N'北京会计', N'负责北京分部日常财务工作', N'8b938c64-6e90-45fc-997f-0e79e5fa1760')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'df10dfae-989c-45f7-8b8f-5c3e07b5d81d', N'北京出纳', N'负责北京分部现金管理', N'8b938c64-6e90-45fc-997f-0e79e5fa1760')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'161e6b29-2b23-437e-a1b3-e8bc9df2476a', N'北京人事经理', N'负责北京分部人事管理', N'd8b23e19-729d-4aed-81dc-99c68f51ff33')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'a9d45f69-5410-4b6a-a6f4-e5e3802a9bf8', N'北京招聘专员', N'负责北京分部人员招聘', N'd8b23e19-729d-4aed-81dc-99c68f51ff33')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'7de3127b-32bd-44ce-8805-0a18a94a1cae', N'北京培训专员', N'负责北京分部人员培训', N'd8b23e19-729d-4aed-81dc-99c68f51ff33')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'ebb3dc07-fb66-4682-a5f2-196ddf9f1691', N'北京市场经理', N'负责北京分部市场管理', N'9cc2a0c1-6ab6-4d27-8f29-af36ba671be1')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'e5ad10d0-09f3-4234-b4c5-70c7c2536b49', N'北京市场调研员', N'负责北京分部市场调研工作', N'9cc2a0c1-6ab6-4d27-8f29-af36ba671be1')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'a6273582-85a4-4f3f-9e5c-42be2e93efca', N'北京市场推广员', N'负责北京分部市场推广工作', N'9cc2a0c1-6ab6-4d27-8f29-af36ba671be1')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'0810b0eb-1c8c-490a-867f-897544084e51', N'北京研发经理', N'负责北京分部研发管理', N'e53e01e9-e687-4ab1-ae43-ee887b65c5ef')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'92f948b8-e269-4ca4-b32e-5733fdf0e127', N'北京产品研发工程师', N'负责北京分部产品研发', N'e53e01e9-e687-4ab1-ae43-ee887b65c5ef')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'8eaa0594-9f19-4c95-9511-4ea63d643946', N'北京产品维护工程师', N'负责北京分部产品维护', N'e53e01e9-e687-4ab1-ae43-ee887b65c5ef')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'5c47e4d5-ebfb-466a-b081-baaa7a29f5a7', N'上海财务经理', N'负责上海分部财务管理', N'209cfc03-9156-4b52-9c3c-3e637cfed459')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'cf7280ee-4c87-4e75-b09c-243db25059fd', N'上海会计', N'负责上海分部日常财务工作', N'209cfc03-9156-4b52-9c3c-3e637cfed459')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'8872c454-93f6-47f2-a0d5-9641b58519f5', N'上海出纳', N'负责上海分部现金管理', N'209cfc03-9156-4b52-9c3c-3e637cfed459')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'2839be6c-e916-494e-ac0a-1a7f4dfb07e6', N'上海人事经理', N'负责上海分部人事管理', N'd639d418-0c71-4989-b01a-629d83df2f19')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'bbd06010-ca4f-4d3c-8f27-40569a12da8a', N'上海招聘专员', N'负责上海分部人员招聘', N'd639d418-0c71-4989-b01a-629d83df2f19')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'15507a6c-c14a-4841-af11-96b7ab33d13f', N'上海培训专员', N'负责上海分部人员培训', N'd639d418-0c71-4989-b01a-629d83df2f19')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'18acb830-c9e0-4f98-b044-b73ddee5351a', N'上海市场经理', N'负责上海分部市场管理', N'4a3a2fb8-da81-495d-b1ca-f6146357b515')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'179e37d3-4089-4a1e-905d-fd869decc76f', N'上海市场调研员', N'负责上海分部市场调研工作', N'4a3a2fb8-da81-495d-b1ca-f6146357b515')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'f8711664-a32d-44fe-85f5-b2700a958dd5', N'上海市场推广员', N'负责上海分部市场推广工作', N'4a3a2fb8-da81-495d-b1ca-f6146357b515')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'9cea4274-3356-40e9-b6f7-ee92b2710b41', N'上海研发经理', N'负责上海分部研发管理', N'3a4f83e3-8e90-4751-9cf0-f5efc3bc948d')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'3c9b3c27-837b-4f57-adf9-846ca765d8c2', N'上海产品研发工程师', N'负责上海分部产品研发', N'3a4f83e3-8e90-4751-9cf0-f5efc3bc948d')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'8e2e4145-8ce1-44da-9fcc-631f70319a97', N'上海产品维护工程师', N'负责上海分部产品维护', N'3a4f83e3-8e90-4751-9cf0-f5efc3bc948d')
INSERT [dbo].[Posts] ([Id], [Name], [Description], [DepartmentId]) VALUES (N'e3f17739-b900-4c78-b66c-da7be90e16fb', N'网络管理员', N'负责网络管理', N'd3f188b3-4af8-4abd-944b-cbde07edcf50')
GO
INSERT [dbo].[RuleDataLinks] ([Id], [RuleId], [DataTypeId]) VALUES (N'6763ada5-c568-4ada-bf9f-bc43e2908634', N'6c1a90f6-d63c-43d1-8c7c-08dcb7515fbe', N'd2bf4f82-2893-4183-b71e-bfd5f9d4170a')
INSERT [dbo].[RuleDataLinks] ([Id], [RuleId], [DataTypeId]) VALUES (N'0836d8b3-03d8-4408-b306-eaf99324b1c6', N'cecfba27-bbca-4f12-83c0-17eca656bd56', N'18e52c01-f507-4a5b-a055-28ee3a49e88a')
INSERT [dbo].[RuleDataLinks] ([Id], [RuleId], [DataTypeId]) VALUES (N'5275e650-1295-49ba-bf8d-55f891376409', N'c1170dbc-0e4c-43f9-83d2-c0d95b075310', N'febfdc24-deed-4792-974d-68660440d979')
INSERT [dbo].[RuleDataLinks] ([Id], [RuleId], [DataTypeId]) VALUES (N'0e7361af-41a2-4375-b512-80dce1655747', N'c1170dbc-0e4c-43f9-83d2-c0d95b075310', N'd2bf4f82-2893-4183-b71e-bfd5f9d4170a')
INSERT [dbo].[RuleDataLinks] ([Id], [RuleId], [DataTypeId]) VALUES (N'8fd2795d-711d-4c18-8c4d-5e15b0cd94a6', N'c1170dbc-0e4c-43f9-83d2-c0d95b075310', N'793ebfae-0070-4088-a102-e6c96e35b3c0')
GO
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'bb19ba54-fcc9-4cf2-9ea7-25c2268550bb', N'd36d2206-f41b-46b3-83c0-0c27d79ebe94', N'f357acbb-4c1b-4353-aade-a5929ff503ac')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'25afd7dc-053a-439f-b0b4-1c59affb8c83', N'6c1a90f6-d63c-43d1-8c7c-08dcb7515fbe', N'bf17dc53-5092-4081-aeaa-10c13aa10540')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'7f202ce8-476a-4f75-99c1-05fa48e42f73', N'6c1a90f6-d63c-43d1-8c7c-08dcb7515fbe', N'2ee18837-e1ab-493c-936c-bf93f2f6ab79')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'fdf52b60-93b9-4860-97f3-4c31ffbaab52', N'6c1a90f6-d63c-43d1-8c7c-08dcb7515fbe', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'3c98b163-f99d-4ee3-84d1-43458ef722db', N'6c1a90f6-d63c-43d1-8c7c-08dcb7515fbe', N'3ea44a7c-9efb-4864-8aa8-2dfbd731b2ba')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'a913574d-90a0-4033-97c5-7ab8ce91abc0', N'cecfba27-bbca-4f12-83c0-17eca656bd56', N'2ee18837-e1ab-493c-936c-bf93f2f6ab79')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'793593fb-fdec-407a-87a4-2fd142268b04', N'cecfba27-bbca-4f12-83c0-17eca656bd56', N'bf17dc53-5092-4081-aeaa-10c13aa10540')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'18abdb14-0182-45fd-806f-844ee037aeee', N'cecfba27-bbca-4f12-83c0-17eca656bd56', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'bd373229-85b4-457f-a470-d777a244618e', N'717a0d73-e765-4773-031f-08dcbaaeb0a1', N'2ee18837-e1ab-493c-936c-bf93f2f6ab79')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'89e9e527-345c-4ee3-9373-05e3d8c427b4', N'717a0d73-e765-4773-031f-08dcbaaeb0a1', N'bf17dc53-5092-4081-aeaa-10c13aa10540')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'ceb62268-43d5-43c4-b449-6f935e7e1a32', N'717a0d73-e765-4773-031f-08dcbaaeb0a1', N'27fb7119-a411-4f9e-b0ae-2e2b492e29d6')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'f9eb0625-7006-48b6-bcd0-e67fd7a53a25', N'717a0d73-e765-4773-031f-08dcbaaeb0a1', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'a86d513d-af18-49d8-9c8a-d82f0e2da6ce', N'717a0d73-e765-4773-031f-08dcbaaeb0a1', N'bfe148a2-e4d0-4547-a99f-d760a7621fd2')
INSERT [dbo].[RuleMenuLinks] ([Id], [RuleId], [MenuId]) VALUES (N'7f725f7a-a11c-4451-a988-4ed0b8945c0f', N'717a0d73-e765-4773-031f-08dcbaaeb0a1', N'7c296ad4-455d-4559-a9d5-bb3ef7fc0ff3')
GO
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'd36d2206-f41b-46b3-83c0-0c27d79ebe94', N'管理员', N'系统管理员')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'8715836a-2eeb-44c4-a823-b70d0be12cf5', N'财务主管', N'管理财务部相关事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'87ef2532-81ee-4373-bd11-cbac6385bb67', N'人事主管', N'管理人力资源部相关事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'4597d941-1e12-4746-8389-ef23f7c1c7ba', N'市场主管', N'管理市场部相关事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'b5e5ac5a-8218-4ff6-9010-967bd386e22a', N'研发主管', N'管理研发部相关事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'4f963a6f-f2c7-4a3f-ad03-1828f2c89f02', N'财务人员', N'处理财务部日常事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'72add083-17ae-40cc-83ae-a57ddea2459d', N'人事专员', N'处理人力资源部日常事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'eadaa4ea-7a82-4137-9296-08f79caa6f15', N'市场专员', N'处理市场部日常事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'8e08454f-3ebd-4b21-af7b-8ec332a89a38', N'研发人员', N'处理研发部日常事务')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'a23e676b-1e54-4173-8c7b-08dcb7515fbe', N'网络管理员', N'网络')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'6c1a90f6-d63c-43d1-8c7c-08dcb7515fbe', N'硬件设施管理员', N'硬件设施管理员')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'015d39b4-664a-4531-b5ba-dba41cd5326c', N'全球气温', N'呜呜呜呜')
INSERT [dbo].[Rules] ([Id], [Name], [Description]) VALUES (N'717a0d73-e765-4773-031f-08dcbaaeb0a1', N'硬件工程师', N'硬件维护维修')
GO
INSERT [dbo].[UserMenuAuthorityLinks] ([Id], [UserId], [MenuId]) VALUES (N'18e52c01-f507-4a5b-a055-28ee3a49e88a', N'f9f19566-d26c-4a85-8363-96c03e0b8203', N'1d4a3d6c-1b0c-40e7-aad8-ededb7968d89')
INSERT [dbo].[UserMenuAuthorityLinks] ([Id], [UserId], [MenuId]) VALUES (N'a211faf3-aec0-4c49-86dc-f567c6e4229e', N'28e0b8d1-d709-431b-9f30-08dcb84a04d4', N'bf17dc53-5092-4081-aeaa-10c13aa10540')
INSERT [dbo].[UserMenuAuthorityLinks] ([Id], [UserId], [MenuId]) VALUES (N'077db2ce-b97e-4aee-b6fc-39b9f23161d4', N'28e0b8d1-d709-431b-9f30-08dcb84a04d4', N'f0685ad9-0405-49d2-8c96-aa5469fe2f31')
INSERT [dbo].[UserMenuAuthorityLinks] ([Id], [UserId], [MenuId]) VALUES (N'c41bcf18-9797-4b76-8c4f-68a9d6868a70', N'28e0b8d1-d709-431b-9f30-08dcb84a04d4', N'2ee18837-e1ab-493c-936c-bf93f2f6ab79')
INSERT [dbo].[UserMenuAuthorityLinks] ([Id], [UserId], [MenuId]) VALUES (N'ba9ed836-0f58-4cf9-ac02-7b901f979347', N'28e0b8d1-d709-431b-9f30-08dcb84a04d4', N'3ea44a7c-9efb-4864-8aa8-2dfbd731b2ba')
GO
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'a7d1e9c4-8851-4fde-b7e5-b169c2e498c2', N'f9f19566-d26c-4a85-8363-96c03e0b8203', N'd36d2206-f41b-46b3-83c0-0c27d79ebe94')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'febfdc24-deed-4792-974d-68660440d979', N'4d3421cb-1d19-4bd6-a85d-ff021ab77df3', N'6c1a90f6-d63c-43d1-8c7c-08dcb7515fbe')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'ce6f7148-c99d-463b-9594-bde5e534f435', N'f9f19566-d26c-4a85-8363-96c03e0b8203', N'a23e676b-1e54-4173-8c7b-08dcb7515fbe')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'80f0d1c2-a26d-42d9-a1f2-76f4703244b8', N'85afd3f9-9d78-4e87-90c6-bfa55b0f45ad', N'8715836a-2eeb-44c4-a823-b70d0be12cf5')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'7bf7870f-04f6-4f20-a79b-20e0f2a3ae81', N'd88a0bbc-1f90-4d09-8c43-88d9952c809d', N'd36d2206-f41b-46b3-83c0-0c27d79ebe94')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'57c15743-7565-4d7a-b2fe-c62e2e22b6d5', N'd88a0bbc-1f90-4d09-8c43-88d9952c809d', N'8715836a-2eeb-44c4-a823-b70d0be12cf5')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'e2c4df8c-5537-4b07-9290-4c5c207ae318', N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'd36d2206-f41b-46b3-83c0-0c27d79ebe94')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'b88ce108-7489-44d4-a1d5-84fedfc3f51f', N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'87ef2532-81ee-4373-bd11-cbac6385bb67')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'21b31fa3-f194-431b-a84f-2b83e54cb1b6', N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'4597d941-1e12-4746-8389-ef23f7c1c7ba')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'99872013-fd0a-46da-8acc-a5a996ea57f6', N'46a8bfb4-b6e0-4c22-b778-1158033f75a6', N'c1170dbc-0e4c-43f9-83d2-c0d95b075310')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'19bc116b-8a12-4e6e-a8c4-e814e04f36b3', N'46a8bfb4-b6e0-4c22-b778-1158033f75a6', N'717a0d73-e765-4773-031f-08dcbaaeb0a1')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'f41dcca5-28ac-4748-9740-ddf4f13022a4', N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'4597d941-1e12-4746-8389-ef23f7c1c7ba')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'e87a30ca-4cde-42e9-bfc9-e77231a3e907', N'85afd3f9-9d78-4e87-90c6-bfa55b0f45ad', N'8715836a-2eeb-44c4-a823-b70d0be12cf5')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'59b393d7-d2c9-401d-82cb-298d79322a43', N'85afd3f9-9d78-4e87-90c6-bfa55b0f45ad', N'87ef2532-81ee-4373-bd11-cbac6385bb67')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'32a3dfa8-7e47-443a-a682-82c7bf5e2348', N'85afd3f9-9d78-4e87-90c6-bfa55b0f45ad', N'4597d941-1e12-4746-8389-ef23f7c1c7ba')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'7f65c28d-fcad-45e8-a1f2-c2d1fbaf3879', N'740918a9-60e4-4f89-aa99-d7712a4be975', N'8715836a-2eeb-44c4-a823-b70d0be12cf5')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'fc699a68-dbb8-4dd8-917b-4fa02cd72e1d', N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'd36d2206-f41b-46b3-83c0-0c27d79ebe94')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'0f5a5251-ce57-4660-9419-f27ea4f6e662', N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'87ef2532-81ee-4373-bd11-cbac6385bb67')
INSERT [dbo].[UserRuleLinks] ([Id], [UserId], [RuleId]) VALUES (N'd4a57db9-9d06-425b-83a6-f52171212e77', N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'8715836a-2eeb-44c4-a823-b70d0be12cf5')
GO
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'85afd3f9-9d78-4e87-90c6-bfa55b0f45ad', N'user1', N'user1@example.com', N'1234567890', 1, N'25f9e794323b453885f5181f1b624d0b', 0, N'2024-07-12', N'2024/8/7 14:55:25', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'd532a948-aa15-45a9-8a19-12e1281f1922', N'root', N'root@example.com', N'0987654321', 0, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-07-12', N'', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'f9f19566-d26c-4a85-8363-96c03e0b8203', N'admin', N'admin@example.com', N'1122334455', 0, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-07-14', N'', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'bdb209ed-136e-4d47-95db-66456e4a8810', N'user2', N'user2@example.com', N'9876543210', 0, N'e10adc3949ba59abbe56e057f20f883e', 1, N'2024-07-14', N'', N'2024/8/7 15:58:38')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'd88a0bbc-1f90-4d09-8c43-88d9952c809d', N'user3', N'user3@example.com', N'0123456789', 1, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-07-14', N'2024/8/7 14:57:13', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'27614751-934a-42d5-a744-a9f10f46d9ee', N'user20', N'user20@example.com', N'6543210987', 0, N'e10adc3949ba59abbe56e057f20f883e', 1, N'2024-07-12', N'', N'2024/8/7 15:58:33')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'd8ccf833-42e1-4e6d-9388-5f7197ab8e86', N'user4', N'user4@example.com', N'444-555-6666', 1, N'E10ADC3949BA59ABBE56E057F20F883E', 1, N'2024-07-20', N'2024-07-21', N'2024/8/7 15:58:35')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'b2bb4541-ae55-47b2-b5c9-3c72daffd7f2', N'user5', N'user5@example.com', N'555-666-7777', 0, N'E10ADC3949BA59ABBE56E057F20F883E', 1, N'2024-07-20', N'', N'2024/8/7 15:58:29')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'a89d138b-a606-49d8-8d23-db114f2d7076', N'user6', N'user6@example.com', N'666-777-8888', 1, N'E10ADC3949BA59ABBE56E057F20F883E', 1, N'2024-07-20', N'2024-07-21', N'2024/8/7 15:50:31')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'd1d0d2e9-c3b9-48fb-b4d3-19cb8233f88a', N'user7', N'user7@example.com', N'777-888-9999', 0, N'E10ADC3949BA59ABBE56E057F20F883E', 1, N'2024-08-05', N'', N'2024/8/7 15:53:37')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'c255edeb-84ef-4bb4-91e2-96b648395187', N'mpdf777', N'1232132131@qq.com', N'32132132143243', 1, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-08-08 09:58:57', N'2024/8/8 10:23:55', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'6be08857-0354-4112-955f-1588da758c88', N'hsr0001', N'dewq@qq.com', N'321321132e', 1, N'25f9e794323b453885f5181f1b624d0b', 0, N'2024-08-08 09:59:25', N'2024/8/8 10:24:01', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'740918a9-60e4-4f89-aa99-d7712a4be975', N'dsadsa', N'e2132@qq.com', N'2312342432', 0, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-08-08 09:59:39', N'', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'28e0b8d1-d709-431b-9f30-08dcb84a04d4', N'hongsaorou666', N'dfwqeq@qq.com', N'2132132132132', 0, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-08-07 16:10:41', N'', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'11e843ac-7fe6-45ff-9f31-08dcb84a04d4', N'hongsaorou666', N'dfwqeq@qq.com', N'2132132132132', 0, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-08-07 16:10:41', N'', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'46a8bfb4-b6e0-4c22-b778-1158033f75a6', N'suancaiyu', N'suancaiyu@qq.com', N'109876382', 0, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-08-07 16:07:59', N'', N'')
INSERT [dbo].[Users] ([Id], [Username], [Email], [Phone], [IsActive], [Password], [IsDeleted], [CreateDate], [BanDate], [DeleteDate]) VALUES (N'f2f9b433-cdb0-4e18-af7c-303535f1b7fe', N'hongsaorou666', N'dfwqeq@qq.com', N'2132132132132', 0, N'e10adc3949ba59abbe56e057f20f883e', 0, N'2024-08-07 16:10:41', N'', N'')
GO
ALTER TABLE [dbo].[Menus] ADD  DEFAULT ((5)) FOR [Priority]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Departments'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'菜单表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Menus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作岗位部门链接' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'PostDepartmentLinks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工作岗位' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Posts'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'角色表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Rules'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户表与部门表的中间表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserDepartmentLinks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户菜单权限表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserMenuAuthorityLinks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户岗位对应' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserPostLinks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户角色表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'UserRuleLinks'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Users', @level2type=N'COLUMN',@level2name=N'CreateDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Users', @level2type=N'COLUMN',@level2name=N'BanDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Users', @level2type=N'COLUMN',@level2name=N'DeleteDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户信息表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Users'
GO
USE [master]
GO
ALTER DATABASE [WebSMS] SET  READ_WRITE
GO
